data acces page connect to sql server

[JACK88]

Hi, i cannot figure out the address host name when i want to connect my data
acces page to the microsoft OLE DB PROvider for sql server so that i can link
(in data link properties) my data access page to the sql server. The
following address I was given are

ODBC:
Driver={SQL Server}; Server=jack8.db.2965895.hostedresource.com;
Database=jack8; Uid=jack8; Pwd='your password';

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data Source=jack8.db.2965895.hostedresource.com; Initial
Catalog=jack8; User ID=jack8; Password='your password';

SqlConnection (.NET):
Data Source=jack8.db.2965895.hostedresource.com; Initial Catalog=jack8; User
ID=jack8; Password='your password';

Thxs.

Confused: Is this the right way to display my drop down combo box in the data
access page by linking the data access page to sql server? Or is there more
correct way?

Thxs. Jack

 

[Pete D.]

This site should help
http://www.carlprothman.net/Default.aspx?tabid=81

 

[Sylvain Lafontaine]

These parameters look OK. However, a lot of potential problems could block
the connection even if the parameters are OK; like a firewall for example.

The first thing to check would be to remove any blank space after each « ; »
(don't remember if it's important or not); the second would be to specify
the protocol to be used as well as the port (often but not necessarily 14330
by adding the name of the library (network) or one of the prefix tcp: or np:
; for example:

ODBC:
Driver={SQL Server}; Server=jack8.db.2965895.hostedresource.com;
Database=jack8; Uid=jack8; Pwd='your password';Network=DBMSSOCN

ODBC:
Driver={SQL Server}; Server=jack8.db.2965895.hostedresource.com,1433;
Database=jack8; Uid=jack8; Pwd='your password';Network=DBMSSOCN

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data Source=tcp:jack8.db.2965895.hostedresource.com;
Initial
Catalog=jack8; User ID=jack8; Password='your password';

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data Source=tcp:jack8.db.2965895.hostedresource.com,1433;
Initial
Catalog=jack8; User ID=jack8; Password='your password';

Using an Alias (see SQL-Server Client Network Utility or something like
that, depends of the version of SQL-Server used on your local machine) will
often solve some of these connection problems. A fourth thing to try would
be to connect using another program such as Enterprise Manager or SQL-Server
Management Studio to see if there is anything wrong with the setup of your
Data Access Page. You also don't say if you're able to connection to any
other SQL-Server like an instance on your local machine. Trying to ping the
address could also be a good idea.

If the SQL-Server is not the default instance but a named instance, then you
must add the name of the instance after the address of the server (but
before the port number). However, as these parameters have been given to
you; I don't think that's your problem here. Finally, you can take a look
at the following articles to help you troubleshooting connection problem:

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

http://msdn2.microsoft.com/en-us/library/ms345318.aspx

Hi, i cannot figure out the address host name when i want to connect my
data
acces page to the microsoft OLE DB PROvider for sql server so that i can
link
(in data link properties) my data access page to the sql server. The
following address I was given are

ODBC:
Driver={SQL Server}; Server=jack8.db.2965895.hostedresource.com;
Database=jack8; Uid=jack8; Pwd='your password';

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data Source=jack8.db.2965895.hostedresource.com;
Initial
Catalog=jack8; User ID=jack8; Password='your password';

SqlConnection (.NET):
Data Source=jack8.db.2965895.hostedresource.com; Initial Catalog=jack8;
User
ID=jack8; Password='your password';

Thxs.

Confused: Is this the right way to display my drop down combo box in the
data
access page by linking the data access page to sql server? Or is there
more
correct way?

The correct way is not to use Data Access Pages anymore. This technology is
practically dead and is a lost of time. While there are more or less easy
to start up with at the beginning; later, they become practically impossible
to use/develop when you want to do anything more advanced than a simple
basic form. Believe me, I know from personal experience. They're also
subject to the main problem of modern security: they're usually blocked by
any intervening firewall and deblocking the firewall to let them go
through - when you have the permission to do so - is puncturing a big hole
into it.

In my opinion, you should stop trying to use this old stuff and switch to
something like ASP.NET.

Thxs. Jack

Happy New Year 2009!

 

[a a r o n _ k e m p f]

it's funny you should say that.

I think that DAP is probably the most important, mission critical
component that Microsoft has ever delivered.

They embed 'Office Web Components' in about 20 other products.

I believe that we should all stand in unison, _BEGGING_ Microsoft to
change OWC to openSource instead of just killing it.

It's by far the most beautiful web-based spreadsheet that I've ever
seen in my whole life.
It can do Olap Reporting-- it's just a fantastic fucking product.

 

[a a r o n _ k e m p f]

and for the record, moving to ASP.net is not reccomended, because it
runs slower and it complicates things on the clientside without any
real benefit

 

[a a r o n _ k e m p f]

I tried to PING your ServerName, and it gave me a 10.6 address.. isn't
this a _LOCAL_ connection (for your internal network) not on the
public network?

you can look it up at www.whatsthisip.com

http://ws.arin.net/whois/?queryinput=10.6.165.52
NetRange: 10.0.0.0 - 10.255.255.255 <---- DEFINITELY REINFORCES THAT
10.6 IS A PRIVATE IP ADDRESS, I MAINLY USE 10.0.X.X for subnet stuff
CIDR: 10.0.0.0/8
NetName: RESERVED-10
NetHandle: NET-10-0-0-0-1

it appears to me that this is a local IP address, you'd need to get
them to give you a _PUBLIC_ dns name for this server connection

 

[JACK88 via AccessMonster.com]

These parameters look OK. However, a lot of potential problems could block
the connection even if the parameters are OK; like a firewall for example.

The first thing to check would be to remove any blank space after each « ; »
(don't remember if it's important or not); the second would be to specify
the protocol to be used as well as the port (often but not necessarily 14330
by adding the name of the library (network) or one of the prefix tcp: or np:
; for example:

ODBC:
Driver={SQL Server}; Server=jack8.db.2965895.hostedresource.com;
Database=jack8; Uid=jack8; Pwd='your password';Network=DBMSSOCN

ODBC:
Driver={SQL Server}; Server=jack8.db.2965895.hostedresource.com,1433;
Database=jack8; Uid=jack8; Pwd='your password';Network=DBMSSOCN

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data Source=tcp:jack8.db.2965895.hostedresource.com;
Initial
Catalog=jack8; User ID=jack8; Password='your password';

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data Source=tcp:jack8.db.2965895.hostedresource.com,1433;
Initial
Catalog=jack8; User ID=jack8; Password='your password';

Using an Alias (see SQL-Server Client Network Utility or something like
that, depends of the version of SQL-Server used on your local machine) will
often solve some of these connection problems. A fourth thing to try would
be to connect using another program such as Enterprise Manager or SQL-Server
Management Studio to see if there is anything wrong with the setup of your
Data Access Page. You also don't say if you're able to connection to any
other SQL-Server like an instance on your local machine. Trying to ping the
address could also be a good idea.

If the SQL-Server is not the default instance but a named instance, then you
must add the name of the instance after the address of the server (but
before the port number). However, as these parameters have been given to
you; I don't think that's your problem here. Finally, you can take a look
at the following articles to help you troubleshooting connection problem:

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

http://msdn2.microsoft.com/en-us/library/ms345318.aspx

Hi, i cannot figure out the address host name when i want to connect my
data

[quoted text clipped - 24 lines]

more
correct way?

The correct way is not to use Data Access Pages anymore. This technology is
practically dead and is a lost of time. While there are more or less easy
to start up with at the beginning; later, they become practically impossible
to use/develop when you want to do anything more advanced than a simple
basic form. Believe me, I know from personal experience. They're also
subject to the main problem of modern security: they're usually blocked by
any intervening firewall and deblocking the firewall to let them go
through - when you have the permission to do so - is puncturing a big hole
into it.

In my opinion, you should stop trying to use this old stuff and switch to
something like ASP.NET.

Thxs. Jack

Happy New Year 2009!

HAPPY NEW YEAR TOO, Sylvain!!

How to get from my access database into asp.net? and how to install into the
web? Thxs.


Jack

 

[Sylvain Lafontaine]

Oh, switching to ASP.NET is not an easy thing and there are a lot of things
to learn! It's not as simple as doing a few clicks here and there with a
wizard. However, if you want to master your future, it's a good idea to
start learning it now.

On the following page, you'll find many introductory texts and videos to
ASP.NET and you can also download the Visual Web Developer for free. (Like
SQL-Express and SQL-Server 2008, the VWD is the free version of its bigger
brother, the VisualStudio.NET 2008.). Look under the Welcome section in the
upper left of: www.asp.net

You can also take a look at the ASP.NET section of the MSDN web site:
http://msdn.microsoft.com/en-us/asp.net/default.aspx

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

These parameters look OK. However, a lot of potential problems could
block
the connection even if the parameters are OK; like a firewall for example.

The first thing to check would be to remove any blank space after each «
; »
(don't remember if it's important or not); the second would be to specify
the protocol to be used as well as the port (often but not necessarily
14330
by adding the name of the library (network) or one of the prefix tcp: or
np:
; for example:

ODBC:
Driver={SQL Server}; Server=jack8.db.2965895.hostedresource.com;
Database=jack8; Uid=jack8; Pwd='your password';Network=DBMSSOCN

ODBC:
Driver={SQL Server}; Server=jack8.db.2965895.hostedresource.com,1433;
Database=jack8; Uid=jack8; Pwd='your password';Network=DBMSSOCN

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data Source=tcp:jack8.db.2965895.hostedresource.com;
Initial
Catalog=jack8; User ID=jack8; Password='your password';

OLE DB, OleDbConnection (.NET):
Provider=sqloledb; Data
Source=tcp:jack8.db.2965895.hostedresource.com,1433;
Initial
Catalog=jack8; User ID=jack8; Password='your password';

Using an Alias (see SQL-Server Client Network Utility or something like
that, depends of the version of SQL-Server used on your local machine)
will
often solve some of these connection problems. A fourth thing to try
would
be to connect using another program such as Enterprise Manager or
SQL-Server
Management Studio to see if there is anything wrong with the setup of your
Data Access Page. You also don't say if you're able to connection to any
other SQL-Server like an instance on your local machine. Trying to ping
the
address could also be a good idea.

If the SQL-Server is not the default instance but a named instance, then
you
must add the name of the instance after the address of the server (but
before the port number). However, as these parameters have been given to
you; I don't think that's your problem here. Finally, you can take a look
at the following articles to help you troubleshooting connection problem:

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

http://msdn2.microsoft.com/en-us/library/ms345318.aspx

Hi, i cannot figure out the address host name when i want to connect my
data

[quoted text clipped - 24 lines]

more
correct way?

The correct way is not to use Data Access Pages anymore. This technology
is
practically dead and is a lost of time. While there are more or less easy
to start up with at the beginning; later, they become practically
impossible
to use/develop when you want to do anything more advanced than a simple
basic form. Believe me, I know from personal experience. They're also
subject to the main problem of modern security: they're usually blocked by
any intervening firewall and deblocking the firewall to let them go
through - when you have the permission to do so - is puncturing a big hole
into it.

In my opinion, you should stop trying to use this old stuff and switch to
something like ASP.NET.

Thxs. Jack

Happy New Year 2009!

HAPPY NEW YEAR TOO, Sylvain!!

How to get from my access database into asp.net? and how to install into
the
web? Thxs.


Jack

 

[Sylvain Lafontaine]

BTW, I'm not sure if it's simply "Network=DBMSSOCN;" or if it's "Network
Library=DBMSSOCN;".

 

[JACK88 via AccessMonster.com]

Hi,
Thanks guys for the guidance. Actually I only want my web page to display
product lists using list box or combo box, which is connected to data in
access database. I get confused. Is there any simpler way to display product
lists, (which is correlated) like coca cola in first list box then next list
box displays the price per can in web page? Thanxs.

Jack

I tried to PING your ServerName, and it gave me a 10.6 address.. isn't
this a _LOCAL_ connection (for your internal network) not on the
public network?

you can look it up at www.whatsthisip.com

http://ws.arin.net/whois/?queryinput=10.6.165.52
NetRange: 10.0.0.0 - 10.255.255.255 <---- DEFINITELY REINFORCES THAT
10.6 IS A PRIVATE IP ADDRESS, I MAINLY USE 10.0.X.X for subnet stuff
CIDR: 10.0.0.0/8
NetName: RESERVED-10
NetHandle: NET-10-0-0-0-1

it appears to me that this is a local IP address, you'd need to get
them to give you a _PUBLIC_ dns name for this server connection

Hi, i cannot figure out the address host name when i want to connect my data
acces page to the microsoft OLE DB PROvider for sql server so that i can link

[quoted text clipped - 20 lines]

Thxs. Jack