connection string to access remote SQL server?

[cougar]

Hi,

I have tried the following connection string to access a remote SQL Server:

oConn.Open "Provider=M S Remote;" & _
"Remote Server=http://remoteservernam e;" & _
"Remote Provider=SQLOLE DB;" & _
"Data Source=remotese rvername;" & _
"Initial Catalog=databas ename;" & _
"User ID=mylogin" & _
"Password=mypas sword"

I keep getting the error when it tries to execute that code:

Object Variable or With Block Variable not set

Does anyone know what could be wrong? Thanks.

[Tom van Stiphout]

On 1 Oct 2004 05:27:42 -0700, 4i******@gmail. com (cougar) wrote:

Well, since you're not in a With block, you must ask yourself which
Object variable is not set. You're only using a single object variable
in this code: oConn.

-Tom.

Hi,

I have tried the following connection string to access a remote SQL Server:

oConn.Open "Provider=M S Remote;" & _
"Remote Server=http://remoteservernam e;" & _
"Remote Provider=SQLOLE DB;" & _
"Data Source=remotese rvername;" & _
"Initial Catalog=databas ename;" & _
"User ID=mylogin" & _
"Password=mypas sword"

I keep getting the error when it tries to execute that code:

Object Variable or With Block Variable not set

Does anyone know what could be wrong? Thanks.

[Darryl Kerkeslager]

It could be the missing semicolon nafter 'mylogin'
It could be an if/endif block not even involving this block of code;
It could be you have mal-defined oConn;
or any of several other items.

To get a better answer, I would post as close to the code as you can, not
just

"Initial Catalog=databas ename;" & _

which obviously is just an example and not your real code.
Darryl Kerkeslager

"cougar" <4i******@gmail .com> wrote in message
news:cf******** *************** ***@posting.goo gle.com...

Hi,

I have tried the following connection string to access a remote SQL Server:
oConn.Open "Provider=M S Remote;" & _
"Remote Server=http://remoteservernam e;" & _
"Remote Provider=SQLOLE DB;" & _
"Data Source=remotese rvername;" & _
"Initial Catalog=databas ename;" & _
"User ID=mylogin" & _
"Password=mypas sword"

I keep getting the error when it tries to execute that code:

Object Variable or With Block Variable not set

Does anyone know what could be wrong? Thanks.

[user_5701]

yeah, you need to post more information about your code. Sounds like
you didn't define a variable (oConn maybe?). Put some breakpoints in
your code and step through it with the debugger - you should get a
better idea of where your code is wrong.

"Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in message news:<2t******* *************@c omcast.com>...

It could be the missing semicolon nafter 'mylogin'
It could be an if/endif block not even involving this block of code;
It could be you have mal-defined oConn;
or any of several other items.

To get a better answer, I would post as close to the code as you can, not
just

"Initial Catalog=databas ename;" & _

which obviously is just an example and not your real code.
Darryl Kerkeslager

"cougar" <4i******@gmail .com> wrote in message
news:cf******** *************** ***@posting.goo gle.com...

Hi,

I have tried the following connection string to access a remote SQL

Server:

oConn.Open "Provider=M S Remote;" & _
"Remote Server=http://remoteservernam e;" & _
"Remote Provider=SQLOLE DB;" & _
"Data Source=remotese rvername;" & _
"Initial Catalog=databas ename;" & _
"User ID=mylogin" & _
"Password=mypas sword"

I keep getting the error when it tries to execute that code:

Object Variable or With Block Variable not set

Does anyone know what could be wrong? Thanks.