Trying to connect on my local machine

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Try this and see if it works:

'In project references you MUST select

' Microsoft OLE DB Service Component 1.0 Type Library

' This in turn loads oledb32.dll into your project

' then

'

' In project reference you MUST select

' Microsof ActiveX Data Objects 2.8 Library

' This in turn loads Msado15.dll into your project

'

Dim objMSDAC As MSDASC.DataLinks

Set objMSDAC = New MSDASC.DataLinks

Cnn_String = objMSDAC.PromptNew

Cnn.ConnectionString = Cnn_String

This will display a form (contained within oledb32.dll),

click on all the forms buttons - you can create the

connection string and test if it functions properly.

I would set a break point on the code in

the line above and display the string using the debugger.

Let me know if the above works for you.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

Is the Ray-PC\Ray account an administrator on the PC?