473,839 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database Question

Hello, I have to build a program with the future in mind and I need a bit
of guidance from a guru or two. My program will start as a multi-user
Windows Application built with VB.Net and using an Access 2002 database
backend. The future will require that 1. The database be switched with
minimal effort to SQL Server and 2. A Web Application be added to allow web
access to reports generated from the database. At this time, there is no
time line set for when 1 or 2 will come or whether 1 will come before 2.
The key for me is to program the initial application with the future firmly
in grasp so I can reuse code for the web app and upgrade the database
without recoding.

I have had Visual Studio .Net for 2 days and my head has been spun into many
tiny knots. What I have understood is that I can use Access 2002 but I
should use it in Microsoft Server Desktop Engine (MSDE) if I want to
upgrade. Is this info correct?

I have used VB as a front end and Access as a backend in the past and have
always gone with unbound controls. Choosing to make classes that handle
getting/adding/editing/updating records rather than binding using the data
environment. Is this the way to go now with .Net? Or is that a contentious
issue where you are either for databound or against databound programming?

I hope my question(s) aren't too general or unintelligible but as with any
'new' language the first days are the hardest days.

Thanks,

Gerry Dyck
Nov 20 '05 #1
7 2247
I'm not a guru, but I have $0.02 . If you wnat to upgrade to SQL without
recoding anyting I would use MSDE, it uses the SQLClient class vs the OLEDB
class. You can still use a web front end with MSDE and it's much faster. As
for binding the controls that is completely up to you.
"News" <ge*******@shaw .ca> wrote in message
news:VeKEb.7530 21$6C4.304439@p d7tw1no...
Hello, I have to build a program with the future in mind and I need a bit
of guidance from a guru or two. My program will start as a multi-user
Windows Application built with VB.Net and using an Access 2002 database
backend. The future will require that 1. The database be switched with
minimal effort to SQL Server and 2. A Web Application be added to allow web access to reports generated from the database. At this time, there is no
time line set for when 1 or 2 will come or whether 1 will come before 2.
The key for me is to program the initial application with the future firmly in grasp so I can reuse code for the web app and upgrade the database
without recoding.

I have had Visual Studio .Net for 2 days and my head has been spun into many tiny knots. What I have understood is that I can use Access 2002 but I
should use it in Microsoft Server Desktop Engine (MSDE) if I want to
upgrade. Is this info correct?

I have used VB as a front end and Access as a backend in the past and have
always gone with unbound controls. Choosing to make classes that handle
getting/adding/editing/updating records rather than binding using the data
environment. Is this the way to go now with .Net? Or is that a contentious issue where you are either for databound or against databound programming?

I hope my question(s) aren't too general or unintelligible but as with any
'new' language the first days are the hardest days.

Thanks,

Gerry Dyck

Nov 20 '05 #2
Gerry,

I would suggest using MSDE for a few reasons:
(1) There are a number of differences between the SQL syntax, for instance
you can use imbedded VBA directives in Access that you cannot do in SQL
Server (MSDE)
(2) With MSDE you have: Stored procedures, Views and Functions
(3) MSDE security is better then Access
(4) The upgrade path from MSDE to SQL Server is minimal

In terms of bound controls that all depends on your domain problem. dotNet
now exposes dataBinding as and interface so you could implement it in your
business classes rather then directly binding to a dataset. In my opinion
when using a facility like databinding you give up some flexibility for ease
of development. Bascially it is your call, but dotNet gives you more
flexibility then before...

Good Luck,
Dan
"News" <ge*******@shaw .ca> wrote in message
news:VeKEb.7530 21$6C4.304439@p d7tw1no...
Hello, I have to build a program with the future in mind and I need a bit
of guidance from a guru or two. My program will start as a multi-user
Windows Application built with VB.Net and using an Access 2002 database
backend. The future will require that 1. The database be switched with
minimal effort to SQL Server and 2. A Web Application be added to allow web access to reports generated from the database. At this time, there is no
time line set for when 1 or 2 will come or whether 1 will come before 2.
The key for me is to program the initial application with the future firmly in grasp so I can reuse code for the web app and upgrade the database
without recoding.

I have had Visual Studio .Net for 2 days and my head has been spun into many tiny knots. What I have understood is that I can use Access 2002 but I
should use it in Microsoft Server Desktop Engine (MSDE) if I want to
upgrade. Is this info correct?

I have used VB as a front end and Access as a backend in the past and have
always gone with unbound controls. Choosing to make classes that handle
getting/adding/editing/updating records rather than binding using the data
environment. Is this the way to go now with .Net? Or is that a contentious issue where you are either for databound or against databound programming?

I hope my question(s) aren't too general or unintelligible but as with any
'new' language the first days are the hardest days.

Thanks,

Gerry Dyck

Nov 20 '05 #3
Hi Gerry,

I do a lot of database programming, both Access and SQL Server 2000 (more
the latter) using vb .net. Yes, MSDE for sure, although I would opt to
start with SQL Server, but that may not be your call (but put some heat on
the boss).

Data binding is not a contentious issue. I sometimes use data binding, but
more often do not, as I can be more efficient without it in many instances.
Its use for visual representations of data as you continually select is
valuable.

Grids can be very important in .net. The standard that comes with vs is
fine, but not easily manipulated for most real world needs. You may want to
look into something like the Component One True DB Grid, which I use - a
difficult learning curve but well worth it.

Also, pick up a few good books on vb .net and ado .net - Balena, MS Press,
Programming vb .net and Sceppa, also MS press, ado .net. There are also
several titles from Apress that are valuable, especially the books by
Vaughn, Troelson and Appleman.

HTH,

Bernie Yaeger

"News" <ge*******@shaw .ca> wrote in message
news:VeKEb.7530 21$6C4.304439@p d7tw1no...
Hello, I have to build a program with the future in mind and I need a bit
of guidance from a guru or two. My program will start as a multi-user
Windows Application built with VB.Net and using an Access 2002 database
backend. The future will require that 1. The database be switched with
minimal effort to SQL Server and 2. A Web Application be added to allow web access to reports generated from the database. At this time, there is no
time line set for when 1 or 2 will come or whether 1 will come before 2.
The key for me is to program the initial application with the future firmly in grasp so I can reuse code for the web app and upgrade the database
without recoding.

I have had Visual Studio .Net for 2 days and my head has been spun into many tiny knots. What I have understood is that I can use Access 2002 but I
should use it in Microsoft Server Desktop Engine (MSDE) if I want to
upgrade. Is this info correct?

I have used VB as a front end and Access as a backend in the past and have
always gone with unbound controls. Choosing to make classes that handle
getting/adding/editing/updating records rather than binding using the data
environment. Is this the way to go now with .Net? Or is that a contentious issue where you are either for databound or against databound programming?

I hope my question(s) aren't too general or unintelligible but as with any
'new' language the first days are the hardest days.

Thanks,

Gerry Dyck

Nov 20 '05 #4
Gerry,
Having just finished converting an application that used an Access
backend to SQL Server, I'd say start with MSDE. You can always connect to
the database using an Access Data Project to look at data that way if you
want but you will be better off starting as you wish to continue.
Just as a note a long involved calculation on my project using real data
has gone down to 4.5 minutes from 9.5 minutes which is mostly attributed to
using stored procedures with the execution plans cached in the server. In
my case the memory load has also decreased because I was able to do more
complex queries using MSDE/SQL Server which save me from doing some
intermediate steps.

Ron Allen
"News" <ge*******@shaw .ca> wrote in message
news:VeKEb.7530 21$6C4.304439@p d7tw1no...
Hello, I have to build a program with the future in mind and I need a bit
of guidance from a guru or two. My program will start as a multi-user
Windows Application built with VB.Net and using an Access 2002 database
backend. The future will require that 1. The database be switched with
minimal effort to SQL Server and 2. A Web Application be added to allow web access to reports generated from the database. At this time, there is no
time line set for when 1 or 2 will come or whether 1 will come before 2.
The key for me is to program the initial application with the future firmly in grasp so I can reuse code for the web app and upgrade the database
without recoding.

I have had Visual Studio .Net for 2 days and my head has been spun into many tiny knots. What I have understood is that I can use Access 2002 but I
should use it in Microsoft Server Desktop Engine (MSDE) if I want to
upgrade. Is this info correct?

I have used VB as a front end and Access as a backend in the past and have
always gone with unbound controls. Choosing to make classes that handle
getting/adding/editing/updating records rather than binding using the data
environment. Is this the way to go now with .Net? Or is that a contentious issue where you are either for databound or against databound programming?

I hope my question(s) aren't too general or unintelligible but as with any
'new' language the first days are the hardest days.

Thanks,

Gerry Dyck

Nov 20 '05 #5
Thanks for your response Ron as well as Jared, Dan and Bernie.

I seem to be going the right direction. Now I have another question. I
loaded MSDE but I cannot seem to get a connection in VB.Net. In the
connection wizard I am not getting any Server to connect to! I am having
the same problem when I go to "Upsize" my Access database. I am missing a
critical step to allow me to gain access to my MSDE server and of course the
documentation sends me in an endless loop with any help from the new
try-catch commands.

Thanks,
Gerry

"Ron Allen" <rallen@_nospam _src-us.com> wrote in message
news:OM******** ******@tk2msftn gp13.phx.gbl...
Gerry,
Having just finished converting an application that used an Access
backend to SQL Server, I'd say start with MSDE. You can always connect to
the database using an Access Data Project to look at data that way if you
want but you will be better off starting as you wish to continue.
Just as a note a long involved calculation on my project using real data has gone down to 4.5 minutes from 9.5 minutes which is mostly attributed to using stored procedures with the execution plans cached in the server. In
my case the memory load has also decreased because I was able to do more
complex queries using MSDE/SQL Server which save me from doing some
intermediate steps.

Ron Allen
"News" <ge*******@shaw .ca> wrote in message
news:VeKEb.7530 21$6C4.304439@p d7tw1no...
Hello, I have to build a program with the future in mind and I need a bit of guidance from a guru or two. My program will start as a multi-user
Windows Application built with VB.Net and using an Access 2002 database
backend. The future will require that 1. The database be switched with
minimal effort to SQL Server and 2. A Web Application be added to allow

web
access to reports generated from the database. At this time, there is no time line set for when 1 or 2 will come or whether 1 will come before 2.
The key for me is to program the initial application with the future

firmly
in grasp so I can reuse code for the web app and upgrade the database
without recoding.

I have had Visual Studio .Net for 2 days and my head has been spun into

many
tiny knots. What I have understood is that I can use Access 2002 but I
should use it in Microsoft Server Desktop Engine (MSDE) if I want to
upgrade. Is this info correct?

I have used VB as a front end and Access as a backend in the past and have always gone with unbound controls. Choosing to make classes that handle
getting/adding/editing/updating records rather than binding using the data environment. Is this the way to go now with .Net? Or is that a

contentious
issue where you are either for databound or against databound programming?
I hope my question(s) aren't too general or unintelligible but as with any 'new' language the first days are the hardest days.

Thanks,

Gerry Dyck


Nov 20 '05 #6
Gerry,
Is the server running? Are all the services started? I have that "problem"
when trying to connect to MSDE through the connection wizard when I try to
use the drowdown. All you have to do is type in your MSSQLServer name in the
Select or enter a server name box. If that doesn't work try to make the
connection using code.

Try something like this (I'm sure there is a better way to do this but it's
only to test it):

create a button on a form and in the button_click event add

Dim db As New MyCompany.Layer s.Data.Database
db.DataBaseName = "" 'Enter your database name here
db.ServerName = "" 'Enter your server name here
db.Connect()
If db.IsConnected Then
MsgBox("Connect ion Successful")
db.Disconnect()
Else
MsgBox("Connect ion Unsuccessful")
End If
Create a new class and copy and paste this over your class
----------------------------------------------------

Imports System.Data.Sql Client

Namespace MyCompany.Layer s.Data

Public Class Database

Dim mDB As SqlConnection

Dim mDBName As String
Dim mServerName As String
Dim mConnectionStri ng As String

Public Property DataBaseName() As String
Get

End Get
Set(ByVal Value As String)
If Not Value Is Nothing Then Me.mDBName = Value.TrimEnd
UpdateConnectio nString()
End Set
End Property
Public Property ServerName() As String
Get
Return Me.mServerName
End Get
Set(ByVal Value As String)
If Not Value Is Nothing Then Me.mServerName = Value.TrimEnd
UpdateConnectio nString()
End Set
End Property
Public Sub New()
UpdateConnectio nString()
Me.mDB = New SqlConnection(M e.mConnectionSt ring)
End Sub
Private Sub UpdateConnectio nString()
Me.mConnectionS tring = "Data Source=" & Me.mServerName & _
";Initial Catalog=" & Me.mDBName & ";Integrate d
Security=SSPI;"
Me.mDB.Connecti onString = Me.mConnectionS tring
End Sub
Public Function IsConnected() As Boolean
If Me.mDB.State <> ConnectionState .Open Then
Return True
Else
Return False
End If
End Function
Public Sub Connect()
Try
Me.mDB.Open()
Catch ex As Exception
MsgBox("Error connecting " & ex.Message)
'Error handling here
End Try
End Sub
Public Sub Disconnect()
Try
Me.mDB.Close()
Catch ex As Exception
'Error handling here
End Try
End Sub

End Class

End Namespace

"News" <ge*******@shaw .ca> wrote in message
news:XvGFb.7830 16$6C4.463533@p d7tw1no...
Thanks for your response Ron as well as Jared, Dan and Bernie.

I seem to be going the right direction. Now I have another question. I
loaded MSDE but I cannot seem to get a connection in VB.Net. In the
connection wizard I am not getting any Server to connect to! I am having
the same problem when I go to "Upsize" my Access database. I am missing a
critical step to allow me to gain access to my MSDE server and of course the documentation sends me in an endless loop with any help from the new
try-catch commands.

Thanks,
Gerry

"Ron Allen" <rallen@_nospam _src-us.com> wrote in message
news:OM******** ******@tk2msftn gp13.phx.gbl...
Gerry,
Having just finished converting an application that used an Access
backend to SQL Server, I'd say start with MSDE. You can always connect to
the database using an Access Data Project to look at data that way if you want but you will be better off starting as you wish to continue.
Just as a note a long involved calculation on my project using real

data
has gone down to 4.5 minutes from 9.5 minutes which is mostly attributed

to
using stored procedures with the execution plans cached in the server. In my case the memory load has also decreased because I was able to do more
complex queries using MSDE/SQL Server which save me from doing some
intermediate steps.

Ron Allen
"News" <ge*******@shaw .ca> wrote in message
news:VeKEb.7530 21$6C4.304439@p d7tw1no...
Hello, I have to build a program with the future in mind and I need a bit of guidance from a guru or two. My program will start as a multi-user
Windows Application built with VB.Net and using an Access 2002 database backend. The future will require that 1. The database be switched with minimal effort to SQL Server and 2. A Web Application be added to allow web
access to reports generated from the database. At this time, there is no time line set for when 1 or 2 will come or whether 1 will come before
2. The key for me is to program the initial application with the future

firmly
in grasp so I can reuse code for the web app and upgrade the database
without recoding.

I have had Visual Studio .Net for 2 days and my head has been spun into
many
tiny knots. What I have understood is that I can use Access 2002 but

I should use it in Microsoft Server Desktop Engine (MSDE) if I want to
upgrade. Is this info correct?

I have used VB as a front end and Access as a backend in the past and

have always gone with unbound controls. Choosing to make classes that handle getting/adding/editing/updating records rather than binding using the data environment. Is this the way to go now with .Net? Or is that a

contentious
issue where you are either for databound or against databound programming?
I hope my question(s) aren't too general or unintelligible but as with any 'new' language the first days are the hardest days.

Thanks,

Gerry Dyck



Nov 20 '05 #7
Hi Jared.

I've gone into Control Panel - Administrative Tools - Component Services
and the MSDE Instance I created (actually did two) was started (for example
MSSQL$GERRY) as well I started service called SQLAgent#GERRY. I manually
enter MSSQL$GERRY in the Select box of the connection wizard and it still
doesn't work.

At the same time, I want to convert an MSAccess database to use in my
program. So I try using the Upsizing wizard. Again I manually enter
MSSQL$GERRY and I get an error window "Microsoft SQL Server Login"

Connection failed:
SQLState:'01000 '
SQL Server Error:53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen( Connect()).
Connection failed:
SQLState:'08001 '
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied

For Pete's sake, I just want to program in VB.NET to a database. This is
quite frustrating as I haven't learnt anything about .NET and I have had the
program for a week. UUUGGGH.

Maybe there is some kind of primer on using MSDE or something that I haven't
found yet.

Thanks for help Jared,
Gerry

"Jared" <VB***********@ email.com> wrote in message
news:vu******** ****@corp.super news.com...
Gerry,
Is the server running? Are all the services started? I have that "problem"
when trying to connect to MSDE through the connection wizard when I try to
use the drowdown. All you have to do is type in your MSSQLServer name in the Select or enter a server name box. If that doesn't work try to make the
connection using code.

Try something like this (I'm sure there is a better way to do this but it's only to test it):

create a button on a form and in the button_click event add

Dim db As New MyCompany.Layer s.Data.Database
db.DataBaseName = "" 'Enter your database name here
db.ServerName = "" 'Enter your server name here
db.Connect()
If db.IsConnected Then
MsgBox("Connect ion Successful")
db.Disconnect()
Else
MsgBox("Connect ion Unsuccessful")
End If
Create a new class and copy and paste this over your class
----------------------------------------------------

Imports System.Data.Sql Client

Namespace MyCompany.Layer s.Data

Public Class Database

Dim mDB As SqlConnection

Dim mDBName As String
Dim mServerName As String
Dim mConnectionStri ng As String

Public Property DataBaseName() As String
Get

End Get
Set(ByVal Value As String)
If Not Value Is Nothing Then Me.mDBName = Value.TrimEnd
UpdateConnectio nString()
End Set
End Property
Public Property ServerName() As String
Get
Return Me.mServerName
End Get
Set(ByVal Value As String)
If Not Value Is Nothing Then Me.mServerName = Value.TrimEnd UpdateConnectio nString()
End Set
End Property
Public Sub New()
UpdateConnectio nString()
Me.mDB = New SqlConnection(M e.mConnectionSt ring)
End Sub
Private Sub UpdateConnectio nString()
Me.mConnectionS tring = "Data Source=" & Me.mServerName & _
";Initial Catalog=" & Me.mDBName & ";Integrate d
Security=SSPI;"
Me.mDB.Connecti onString = Me.mConnectionS tring
End Sub
Public Function IsConnected() As Boolean
If Me.mDB.State <> ConnectionState .Open Then
Return True
Else
Return False
End If
End Function
Public Sub Connect()
Try
Me.mDB.Open()
Catch ex As Exception
MsgBox("Error connecting " & ex.Message)
'Error handling here
End Try
End Sub
Public Sub Disconnect()
Try
Me.mDB.Close()
Catch ex As Exception
'Error handling here
End Try
End Sub

End Class

End Namespace

"News" <ge*******@shaw .ca> wrote in message
news:XvGFb.7830 16$6C4.463533@p d7tw1no...
Thanks for your response Ron as well as Jared, Dan and Bernie.

I seem to be going the right direction. Now I have another question. I
loaded MSDE but I cannot seem to get a connection in VB.Net. In the
connection wizard I am not getting any Server to connect to! I am having
the same problem when I go to "Upsize" my Access database. I am missing a critical step to allow me to gain access to my MSDE server and of course the
documentation sends me in an endless loop with any help from the new
try-catch commands.

Thanks,
Gerry

"Ron Allen" <rallen@_nospam _src-us.com> wrote in message
news:OM******** ******@tk2msftn gp13.phx.gbl...
Gerry,
Having just finished converting an application that used an Access
backend to SQL Server, I'd say start with MSDE. You can always connect to the database using an Access Data Project to look at data that way if you want but you will be better off starting as you wish to continue.
Just as a note a long involved calculation on my project using
real
data
has gone down to 4.5 minutes from 9.5 minutes which is mostly
attributed to
using stored procedures with the execution plans cached in the server. In my case the memory load has also decreased because I was able to do
more complex queries using MSDE/SQL Server which save me from doing some
intermediate steps.

Ron Allen
"News" <ge*******@shaw .ca> wrote in message
news:VeKEb.7530 21$6C4.304439@p d7tw1no...
> Hello, I have to build a program with the future in mind and I need a bit
> of guidance from a guru or two. My program will start as a
multi-user > Windows Application built with VB.Net and using an Access 2002
database > backend. The future will require that 1. The database be switched with > minimal effort to SQL Server and 2. A Web Application be added to allow web
> access to reports generated from the database. At this time, there is no
> time line set for when 1 or 2 will come or whether 1 will come
before 2. > The key for me is to program the initial application with the future
firmly
> in grasp so I can reuse code for the web app and upgrade the
database > without recoding.
>
> I have had Visual Studio .Net for 2 days and my head has been spun into many
> tiny knots. What I have understood is that I can use Access 2002
but
I > should use it in Microsoft Server Desktop Engine (MSDE) if I want to
> upgrade. Is this info correct?
>
> I have used VB as a front end and Access as a backend in the past
and have
> always gone with unbound controls. Choosing to make classes that handle > getting/adding/editing/updating records rather than binding using

the data
> environment. Is this the way to go now with .Net? Or is that a
contentious
> issue where you are either for databound or against databound

programming?
>
> I hope my question(s) aren't too general or unintelligible but as
with any
> 'new' language the first days are the hardest days.
>
> Thanks,
>
> Gerry Dyck
>
>



Nov 20 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
6071
by: Lee | last post by:
Hi, I'm developing a socket program to connect to Informix database through the ODBC. In here i called my socket program as "tap" . My tap will listen for data from unix through port 1070. After checking of the data, tap will then insert the data to the informix database. I know we can point the tap to one specified port in Informix database through the services file. My question is how should i know to which port my tap program send out...
7
3649
by: Dave | last post by:
I have a system that basically stores a database within a database (I'm sure lots have you have done this before in some form or another). At the end of the day, I'm storing the actual data generically in a column of type nvarchar(4000), but I want to add support for unlimited text. I want to do this in a smart fashion. Right now I am leaning towards putting 2 nullable Value fields: ValueLong ntext nullable ValueShort nvarchar(4000)...
18
7391
by: cjl | last post by:
Hey all: I know that it is silly in the age of Google to 'lose' something on the internet, but I recently checked out a project that had implemented a database with a subset of SQL in pure client-side javascript. I forgot to bookmark it, and now I can't find it. Anyone?
6
3445
by: ronwer | last post by:
Hello, The title doesn't completely cover the question I have, but it's a bit more complicated problem we have. We are using a database, based on Acces, but developed by a third party developer who sells it under his own name. So, functionally it's a very specific database for a specific purpose. Now we want to make certain changes in this database, but for reasons of
8
2570
by: Inspector | last post by:
I'm hoping I might be able to pick someone's brain out there. Our company is currently running an inhouse application in which data is being stored in SQL. Included in this data are thousands (over 100,000) of .jpg images. I am starting to run out of disk space and a developer suggested that we take the images out of SQL and put them in a file. In doing they indicated we could recover the SQL database faster if needed, we could also...
29
3590
by: MP | last post by:
Greets, context: vb6/ado/.mdb/jet 4.0 (no access)/sql beginning learner, first database, planning stages (I think the underlying question here is whether to normalize or not to normalize this one data field - but i'm not sure) :-) Background info:
8
1593
by: mesut | last post by:
Mybe it's a stupid question but : I'm starting to learn VB.NET. I have some basic skills. I'm from Mainframe world and I have same question to make my DATABASES (tables and relation) I would like to make ask my question by example. Let's say I'm a sales company I'm selling products to customers. Okay? I have these tables (databases) and fields and I have these questions. I have created these tables in VB.NET Database Connections IDE...
35
4860
by: Terry Jolly | last post by:
Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection string in the web.config. I created a class with a static database connection and the class opens and closes the database.
2
4727
by: clinttoris | last post by:
Hello, If someone could help me it would be appreciated as I am not having much luck. I'm struggling with my asp code and have some questions relating to asp and oracle database. First question. I have a web survey that I am working on and have successfully dynamically taken the info from a database, displayed it on the screen and then taken the users answers and inserted them into a
5
2336
by: Slant | last post by:
Here's a question that most will have different answers to. I'm just dying to find a solution that seems halfway automated!! There really are two seperate issues which might be answered by the same answer. Web App: - constants.php begin - define("DB_HOST", "locahost"); .... to include the standard connection info define("DB_NAME", "mydatabase");
0
9698
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10910
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10589
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10297
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9426
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7833
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5683
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5867
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3136
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.